create database if not exists regression;
use regression;

CREATE TABLE `crdmm_data`(
  `apply_dt` string,
  `session_id` string,
  `apply_id` string,
  `biz_type` string,
  `begin_time` string,
  `out_finaldecision` string,
  `out_hit_refused_rule` string,
  `out_lending_rate` string,
  `out_creditlimit` string,
  `amt_seg` string,
  `oott_ppddtt_group1` string,
  `oott_ppddtt_group2` string,
  `oott_ppddtt_group3` string,
  `oott_ppddtt_group15` string,
  `oott_ppddtt_group5` string,
  `oott_ppddtt_group6` string,
  `oott_ppddtt_group7` string,
  `oott_ppddtt_group8` string,
  `oott_ppddtt_group9` string,
  `oott_ppddtt_group10` string,
  `oott_ppddtt_group11` string,
  `oott_ppddtt_group12` string,
  `oott_ppddtt_group13` string,
  `oott_ppddtt_group14` string,
  `t01_age` string,
  `age_seg` string,
  `t01_sex` string,
  `t01_mobile_field0` string,
  `t01_mobile_field1` string,
  `t01_origin_field0` string,
  `t01_origin_field1` string,
  `t07_yhdd_field0` string,
  `t07_yhdd_field1` string,
  `t07_yhdd_field2` string,
  `t07_yhdd_field3` string,
  `t06_rh_status` string,
  `had_something` int,
  `t06_rh_gender` string,
  `t06_rh_age` string,
  `t06_rh_marital_state` string,
  `t06_rh_employer_industry` string,
  `t06_rh_current_testxx_overdue_money` string,
  `ttxx_test_field_crdyy_current_overdue_money` string,
  `ttxx_test_field_current_overdue_count` string,
  `ttxx_test_field_crdyy_current_overdue_count` string,
  `ttxx_test_field_crdyy_latest_3_month_overdue_count` string,
  `ttxx_test_field_latest_3_month_overdue_count` string,
  `ttxx_test_field_crdyy_latest_6_month_overdue_count` string,
  `ttxx_test_field_latest_6_month_overdue_count` string,
  `ttxx_test_field_crdyy_latest_12_month_overdue_count` string,
  `ttxx_test_field_latest_12_month_overdue_count` string,
  `ttxx_test_field_crdyy_latest_24_month_overdue_count` string,
  `ttxx_test_field_latest_24_month_overdue_count` string,
  `ttxx_test_field_latest_3_month_max_overdue_count` string,
  `ttxx_test_field_latest_6_month_max_overdue_count` string,
  `ttxx_test_field_latest_12_month_max_overdue_count` string,
  `ttxx_test_field_latest_24_month_max_overdue_count` string,
  `ttxx_test_field_crdyy_latest_3_month_max_overdue_count` string,
  `ttxx_test_field_crdyy_latest_6_month_max_overdue_count` string,
  `ttxx_test_field_crdyy_latest_12_month_max_overdue_count` string,
  `ttxx_test_field_crdyy_latest_24_month_max_overdue_count` string,
  `t06_rh_latest_1_month_cdyy_crdyy_approval_query_count` string,
  `t06_rh_latest_1_month_testxx_approval_query_count` string,
  `t06_rh_latest_3_month_cdyy_crdyy_approval_query_count` string,
  `t06_rh_latest_3_month_testxx_approval_query_count` string,
  `t06_rh_latest_6_month_cdyy_crdyy_approval_query_count` string,
  `t06_rh_latest_6_month_testxx_approval_query_count` string,
  `ttxx_test_field_latest_1_month_hairpin_count` string,
  `ttxx_test_field_latest_3_month_hairpin_count` string,
  `ttxx_test_field_latest_6_month_hairpin_count` string,
  `ttxx_test_field_latest_12_month_hairpin_count` string,
  `month_ffzzhh` double,
  `t06_rh_per_hhoossuu_testxx_count` string,
  `t06_rh_per_business_hhoossuu_testxx_count` string,
  `t06_rh_per_hhoossuu_testxx_current_repayment` string,
  `t06_rh_per_hhoossuu_testxx_max_limit_amount` string,
  `t06_rh_per_hhoossuu_testxx_limit_amount_sum` string,
  `t06_rh_per_hhoossuu_testxx_balance_sum` string,
  `t06_rh_per_ccrr_testxx_count` string,
  `t06_rh_per_ccrr_testxx_balance_sum` string,
  `t06_rh_per_ccrr_testxx_max_limit_amount` string,
  `t06_rh_per_ccrr_testxx_limit_amount_sum` string,
  `t06_rh_per_ccrr_testxx_current_repayment` string,
  `t06_rh_per_business_testxx_limit_amount_sum` string,
  `t06_rh_per_business_testxx_balance_sum` string,
  `t06_rh_per_business_testxx_count` string,
  `t06_rh_per_business_testxx_current_repayment` string,
  `t06_rh_edu_level` string,
  `t06_rh_accumulation_fund_state` string,
  `t06_rh_accumulation_fund_own_percent` string,
  `t06_rh_accumulation_fund_com_percent` string,
  `t06_rh_accumulation_fund_pay` string,
  `t06_rh_accumulation_fund_deposit_base` string,
  `t06_rh_not_destroy_testxx_crdyy_account_count` string,
  `t06_rh_not_destroy_testxx_crdyy_cdyy_limit` string,
  `t06_rh_not_destroy_testxx_crdyy_used_cdyy_limit` string,
  `t06_rh_not_destroy_testxx_crdyy_cdyy_limit_ratio` string,
  `t06_rh_not_destroy_testxx_crdyy_latest_6_month_used_avg_amount` string,
  `t06_rh_not_destroy_testxx_crdyy_min_cdyy_limit_per_org` string,
  `t06_rh_not_destroy_testxx_crdyy_max_cdyy_limit_per_org` string,
  `ttxx_test_field_crdyy_amount_use_exceed_75_percent_num` string,
  `ttxx_test_field_crdyy_amount_use_exceed_90_percent_num` string,
  `t06_rh_standard_testxx_crdyy_amount_use_exceed_75_percent_ratio` string,
  `t06_rh_standard_testxx_crdyy_amount_use_exceed_90_percent_ratio` string,
  `ttxx_test_field_crdyy_latest_1_month_total_repayment` string,
  `t06_rh_per_ccxx_testxx_current_repayment` string,
  `t06_rh_per_ccxx_testxx_max_limit_amount` string,
  `t06_rh_per_ccxx_testxx_limit_amount_sum` string,
  `t06_rh_per_ccxx_testxx_balance_sum` string,
  `t06_rh_per_ccxx_testxx_count` string,
  `t06_rh_per_ccxx_testxx_max_account_age` string,
  `t06_rh_per_ccxx_testxx_min_account_age` string,
  `t06_rh_per_ccxx_testxx_uncleared_max_account_age` string,
  `t06_rh_per_ccxx_testxx_uncleared_min_account_age` string,
  `t06_rh_cdyy_testxx_last_1_month_launch_count` string,
  `t06_rh_cdyy_testxx_last_3_month_launch_count` string,
  `t06_rh_cdyy_testxx_last_6_month_launch_count` string,
  `t06_rh_cdyy_testxx_last_12_month_launch_count` string,
  `t06_rh_cdyy_testxx_last_1_month_launch_cdyy_limit` string,
  `t06_rh_cdyy_testxx_last_3_month_launch_cdyy_limit` string,
  `t06_rh_cdyy_testxx_last_6_month_launch_cdyy_limit` string,
  `t06_rh_cdyy_testxx_last_12_month_launch_cdyy_limit` string,
  `t06_rh_unpaid_testxx_cdyy_limit` string,
  `t06_rh_unpaid_testxx_balance` string,
  `t06_rh_unpaid_testxx_latest_6_month_used_avg_amount` string,
  `t06_rh_cdyy_white_grade` string,
  `t06_rh_first_testxx_open_ago_months` string,
  `t06_rh_first_testxx_crdyy_open_ago_months` string,
  `t06_rh_cdyy_testxx_limit_amount_sum` string,
  `t06_rh_cdyy_testxx_count` string,
  `t06_rh_uncleared_cdyy_testxx_count` string,
  `t06_rh_uncleared_cdyy_testxx_balance_sum` string,
  `t06_rh_uncleared_cdyy_testxx_limit_amount_sum` string,
  `crdmm_testxx_sum_grp` string,
  `pd_prl_cnt_grp` string,
  `upd_prl_pct_grp` string,
  `ttxx_test_field_average_surplus_repay_count` string,
  `t06_rh_d1_testxx_24_overdue_month_count` string,
  `t06_rh_clear_testxx_cnt_l3m` string,
  `t06_rh_last_60d_query_cnt` string,
  `t06_rh_last_0d_testxx_query_cnt` string)
ROW FORMAT SERDE
  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
  'field.delim'=',',
  'line.delim'='\n',
  'serialization.format'=',')
STORED AS INPUTFORMAT
  'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  '/user/doris/suites/regression/crdmm_data/'
TBLPROPERTIES (
  'transient_lastDdlTime'='1685331029');

msck repair table crdmm_data;

